package spectra.ee.web.common.dao.ibatis;

import java.sql.SQLException;
import java.util.List;

import spectra.base.sql.ibatis.SqlMapperWeb;
import spectra.ee.web.common.dao.IConfigPropertyDao;

import com.ibatis.sqlmap.client.SqlMapClient;

/**
 * t_config_property 테이블 Dao 클래스.
 */
public class ConfigPropertyDaoImpl implements IConfigPropertyDao
{

    /** SqlMapClient 객체. */
    SqlMapClient sqlMap = null;

    /**
     * 생성자.
     */
    public ConfigPropertyDaoImpl()
    {
        sqlMap = SqlMapperWeb.getSqlMapWebInstance();
    }

    /**
    * t_config_property테이블에서 웹에서 사용하는(web_use_flag='Y') 환경변수를 가져온다.
    *
    * @return spectra.base.cm.model.ConfigProperty List.<br>
    *  property_id:프라퍼티아이디.<br>
    *  service_id:서비스아이디.<br>
    *  config_node_id:설정노드아이디.<br>
    *  value:값.<br>
    *  value_type:값타입.<br>
    *  option_list:옵션목록.<br>
    *  confirm_flag:확인플래그.<br>
    *  restart_flag:재시작속성여부.<br>
    *  system_flag:콘솔변경가능여부.<br>
    *  sync_flag:동기화플래그.<br>
    *  web_use_flag:웹사용여부.<br>
    *	description:설명.<br>
    *  updated_date:수정일자.<br>
    *
    * @throws SQLException the SQL exception
    */
    public List selectConfigPropertyListForWebConfig() throws SQLException
    {
        return sqlMap.queryForList("ConfigProperty.selectConfigPropertyListForWebConfig", null);
    }
}
